Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I am having 3 fields
FieldA FieldB FieldC
* * *
- - -
R S T
I am joining the above 3 fields FieldA & FieldB & FieldC as New Field.
But here I am getting output field as
New Field
---
---R---
ST
***
---S---
---T---
But My output must be like this
New Field
-
*
S
T
R
Is any way to acheive this one, Can any one please help me on this?
Thanks in Advance,
what do you want to achieve based on your sample data?
After Concatenating 3 fields in to one field in sample 2 data and then I need to do left join with Sample 1 data
what is expected output you need? both the files having same data
Sorry,
By mistake I uploded same files.
Now What I am expecting is In sample 2 data we have fields Field A, Field B, Field C we need to concatenate these 3 fields in to single field and after we need to do left join this data to sample1data.
Like this ?
Yes This is what I need Can you Please share the Qvw
See Attachment.
Hi Antonio,
As I observed the records get tripled in your attached qvw when your joining. This is because of using Substring?
Thanks,
Chinnu.
This is the behavior of SubString() function without 3rd parameter