Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How can i do the following in the script:
Input:
Data | Group1 | Group2 | Group3
1 A B C
2 A D C
Output:
Data | Group
1 A
1 B
1 C
2 A
2 D
2 C
Thanks in advance.
Input:
LOAD * Inline [
Data , Group1 , Group2 , Group3
1, A, B, C
2, A, D, C
];
Final:
Crosstable(Data1, Group,1)
LOAD
Data,
Group1,
Group2,
Group3
Resident Input;
Drop fields Data1 from Final;
Drop Tables Input;
Use the CrossTable function preceding your LOAD statement in your script, e.g.
Crosstable(Data, Group,1)
LOAD
Data,
Group1,
Group2,
Group3
Resident Input;
This is the code:
let me know
Input:
LOAD * Inline [
Data , Group1 , Group2 , Group3
1, A, B, C
2, A, D, C
];
MyTable1: NoConcatenate
LOAD Data Resident Input;
Left Join
LOAD Data, Group1 as Group Resident Input;
MyTable2: NoConcatenate
LOAD Data Resident Input;
Left Join
LOAD Data, Group2 as Group Resident Input;
MyTable3: NoConcatenate
LOAD Data Resident Input;
Left Join
LOAD Data, Group3 as Group Resident Input;
DROP Table Input;
MyTable:
NoConcatenate
LOAD * Resident MyTable1;
Concatenate
LOAD * Resident MyTable2;
Concatenate
LOAD * Resident MyTable3;
DROP Tables MyTable1, MyTable2, MyTable3;
Input:
LOAD * Inline [
Data , Group1 , Group2 , Group3
1, A, B, C
2, A, D, C
];
Final:
Crosstable(Data1, Group,1)
LOAD
Data,
Group1,
Group2,
Group3
Resident Input;
Drop fields Data1 from Final;
Drop Tables Input;
Crosstable is the best Solution I know but my example is a useful exercise to manage tables!
Hi,
One more solution
TEMP:
LOAD * INLINE [
Data, Group1, Group2, Group3
1, A, B, C
2, A, D, C
];
FINAL:
LOAD Data,
Group1 as Group
Resident TEMP;
join
LOAD Data,
Group2 as Group
Resident TEMP;
join
LOAD Data,
Group3 as Group
Resident TEMP;
DROP table TEMP;
Regards