DSXchange

Duble click on your transformer. Drag the column that comes from input and drop it in the lookup column where it needs to get looked upon.

Please check whether it helps.

http://dsxchange.com/viewtopic.php?t=13 ... 69f5ef6686

Yes Criag. That SQL was taken from this forum only.
We can create a simple server job with universe stage to execute this SQL.

I think you can tweak the below query running in Universe tables for your need. SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY , DS_JOBOBJECTS.NAME AS OBJECT_NAME , DS_JOBOBJECTS.OLETYPE , EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),'YOUR_FIELD_NAME',1) > 0 then 'FOUND' else ''" AS REC...

I am also getting same error. Let me know if there are any updates in this

I remember we did like this. Transformer can be connected to Link collector. Please try. If it gives error post the error message.

Using transformer and link collector. In target table, select upsert mode.
For more details, please search in this forum.

Can you try this
Convert(Convert('0123456789','','XYZ123.45ABC'),'','XYZ123.45ABC')

How did you try ? Can you please paste your exact statement

Check convert function

You should not include timestamp for hash partitioning for Scenario1

1. Use DSGetJobInfo to get the list of active stages in your job
2. Use DSGetStageInfo to get the list of links for a stage.
3. Use DSGetLinkInfo to get the row counts on each link you need.

For more details on do a search on those functions in this forum.

You can create a simple server routine to get those values and mail it

Hi,
I am aware that by creating a VOC pointer to a hashed file, we can delete a particular row from Adiministrator command prompt. I tried the same for a dataset. But it is throwing me a error. What are the otherways that I can follow to delete a particular row from dataset

Please do a search in this forum and see whether it helps.