Help me.

[#1]

temp:

LOAD * INLINE [

    BA, ITS, BC

    BA1, ITS1, TIER0

    BA1, ITS2, TIER1

    BA2, ITS3, TIER1

    BA3

];

i have this table . i want to make.

BA	BC
BA1	TIER0
BA2	TIER1
BA3

PLEASE HELP ME TO SOLVE THE PROBLEM.    

[jonathandienst]

Hi

Please provide more information about how you would like to get the result table (ie what rules determine the contents)? Also do you want to do this in script or in the front end?

Without that information I can only guess what you are trying to do.

Jonathan

[#3]

You have to try to explain well your problem because in this way the answer is:

temp:

LOAD * INLINE [

    BA, BC

    BA1, TIER0

    BA2, TIER1

    BA3

];

Gio

[MayilVahanan]

Hi

Try like this

Temp:

LOAD * INLINE [

    BA, ITS, BC

    BA1, ITS1, TIER0

    BA1, ITS2, TIER1

    BA2, ITS3, TIER1

    BA3

];

Load BA, FirstValue(BC) as BC Resident Temp

Group by BA;

DROP Table Temp;

[Clever_Anjos]

PFA

[#6]

Thank you buddy....