Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Team,
Just I want to small help from your side, I have one column which contains the id and name I want to segregate the id separate and name separate.
Please find the below example. which I need.
source column:
TABID. Name | ||
---|---|---|
|
Results:
TGB ID | TGB Name |
---|---|
12345 | AM_DA |
2314 | AMI_Test |
So, I request to you please write the script for segregate the one column into two.
Thanks,
Irshad Ahmad
May be this?
LOAD SubField([TABID. Name], '.', 1) AS [TGB ID], SubField([TABID. Name], '.', 2) AS [TGB Name] Inline [
TABID. Name
12345.AM_DA
2314.AMI_Test
];
Thanks, Anil.
NP, Please close this thread by flag correct answer and helpful. that may easy understand for new users
Hi Anil,
for small changes I going open the loop
could you please tell me how you can use the group by [TGB Name] in this script I tried to use group by but it is throwing error could you write the script for this.
Please share full script and error image, May be
Anil,
Currently, this work in the hold will let you know once it starts.
Thanks.
Irshad Ahmad
you can try below script also:
a:
load * Inline [
idname
12345.AM_DA
2314.AMI_Test
];
result:
LOAD *,
KeepChar(idname,'1234567890') as ID,
PurgeChar(idname,'.1234567890') as nmae
Resident a;