DSXchange

what abt the first one?

okay....!

Any suggestions are welcome....!

I got this error when i explicity gave column length less than the actuall database column length.

so had to change that inside the job, if i have to avoid this error.

Thanks

pretty straight forward expression...dsgurus have already mentioned it. please try it and let us know if you are getting the desired results.

Yes it works now. thanks have a gr8 day

Thanks Arun, i thought u will not check this thread, definately i will check this....

actually i did something like this already....may be i think i shd tweak my if then else more to get more accurate results.

will post the results soon.

I want count for that particular group and there are many groups....

how to deal with your solution if i have more groups?

Source

col1 col2_key
Yes 1
Yes 1
No 1
No 1
Yes 2
Yes 2
NA 3
NA 4

hope this clarifies.

no the key column is coming from source so, based on that i will have more datasets containing counts for which stagvarible+1 combinations is not looking accurate.

Okay folks,

I am splitting the job into two and referencing the hash files in 2nd job which will give me counts and as well as zeros.....thanks for your time and ideas, appreciate it.

sorted by key columns first and then
Tried by adding one more stage variable checking for key column change,
didnt workout.

Yes this logic works for only one set of data,
it should be able to handle different group types(i.e the key column keeps changing)

i can split the job into two, which will definately work, but then i want to use this functionality where i can write and read from the same hash file.

the upper link will be coming from 2nd TFM, and the lower reference link is towards 3rd TFM.



Moderator: like that. The need to use code tags to preserve whitespace has been repeated here a ton of times. I also numbered your transformers for easier reference.