Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want to combine two different fields into one single field then how to do it without using composite key?
the condition is as follows:
Load *Inline [
Region,sub-region,Date
R1 Sb1 1
R2 Sb2 2
R3 Sb3 3
R4 Sb4 4
R5 Sb5 5
];
I want the output as below,
Dimension(field)
R1
R2
R3
R4
R5
Sb1
Sb2
Sb3
Sb4
Sb5
Combining them into 1 field is THE way of doing this (as also mentioned in your previous topic).
Sure, you could glue them together in the front end, but why waste performance on that?
try like this :
Temp:
Load *Inline [
Region,sub-region,Date
R1 Sb1 1
R2 Sb2 2
R3 Sb3 3
R4 Sb4 4
R5 Sb5 5
];
LOAD sub-region as Region
resident
Temp;
But it may lead to wrong result rite?? What is your exact requirement
Please do NOT start the same topic twice (in two different area's).
Other copy rejected and deleted.
How would it lead to the wrong result?
sorry for the wrong condition again iam sending you the same scenario but i want new field to be created i.e, dimension.