Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone
I have a table in excel which looks like this:
but I want to load it as below :
"T2" equal to "T1" when "ID" -1
how does the load script should be looks like ? plz help
thanks a lot
May be as below:
Source_Data:
Load * Inline [
ID,T1
1,A
2,B
3,C
4,D
5,E
];
NoConcatenate
Final:
Load
ID,
T1,
If(ID=1,'',Previous(T1)) as T2
Resident Source_Data;
Drop Table Source_Data;
May be as below:
Source_Data:
Load * Inline [
ID,T1
1,A
2,B
3,C
4,D
5,E
];
NoConcatenate
Final:
Load
ID,
T1,
If(ID=1,'',Previous(T1)) as T2
Resident Source_Data;
Drop Table Source_Data;
Excellent!!!!! thx a ton
Awesome.... Glad able to help out...