Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
Here is the scenario where I would need some idea's on-
I have column Description in one Table and Vendor No in another Table.
example :-
Description Table
No | Description |
1 | R555-10034 Alter state |
2 | R777-10045 Change state |
3 | 56785789907909 |
Vendor Table
Vendor No |
10034 |
45654 |
23435 |
10045 |
So now I have to extract the string from Description Table if it contains the exact vendor No from Vendor Table.
Example : I need to create New Column as shown below-
No | Description | New Column |
1 | R555-10034 Alter state | 10034 |
2 | R777-10045 Change state | 10045 |
3 | 56785789907909 | - |
Note : Only if Vendor No exist in the description Column it should add to new Column as shown above.
I have also tried this condition- if(wildmatch(Description, Vendor No),Vendor No). This did not work!
Let me know how to achieve this, have tried out my best!
Thanks in Advance🙂
LP
Try this
VendorMapping:
Mapping
LOAD [Vendor No],
'/'&[Vendor No]&'\';
LOAD * INLINE [
Vendor No
10034
45654
23435
10045
];
Table:
LOAD *,
TextBetween(MapSubString('VendorMapping', Description), '/', '\') as [New Column];
LOAD * INLINE [
No, Description
1, R555-10034 Alter state
2, R777-10045 Change state
3, 56785789907909
];
Try this
VendorMapping:
Mapping
LOAD [Vendor No],
'/'&[Vendor No]&'\';
LOAD * INLINE [
Vendor No
10034
45654
23435
10045
];
Table:
LOAD *,
TextBetween(MapSubString('VendorMapping', Description), '/', '\') as [New Column];
LOAD * INLINE [
No, Description
1, R555-10034 Alter state
2, R777-10045 Change state
3, 56785789907909
];
Wow! that solved my issue.
Thanks @sunny_talwar