Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day!
In my model i have two fields:
Id,
Name
Values in field Id is unique, but there may be several Names for one Id.
How in load script to concat Names for every Id, if count(Name)>0 for one Id?
Example:
Source:
Id Name
1 Name1_First
1 Name1_Second
2 Name2_First
Must be:
Id Name
1 Name1_First & Name1_Second
2 Name2_First
There're model and source file in attachment
Thanks.
Load ID,
Concat(Name,' & ') as Name
From Source
group by ID;
Hi,
Try this:
Table:
LOAD Id,
Concat(Name, ' ') as "Name"
FROM ...
Group by Id;
Thanks! Good work
Thanks!!
new table: Load field1, concat(field2,’-’)as concatlist