Split the filed value and concatenate reverse

[jagdishbr]

Can you please help me with Splitting the field value and concatenate:

Analyst Name(Current)

Gates, Bill

Haigh, John

Dundas, Caitlin

Analyst Name(Needed)

Bill Gates

John Haigh

Caitlin Dundas

Getting Error as Field Not Found <F2>

Test:

LOAD

AnalystName

FROM

QlikViewDocument.xlsx

(ooxml, embedded labels, table is RDump);

NoConcatenate

ConCat_test:

LOAD

SubField(AnalystName, ',', 1) as F1,

SubField(AnalystName, ',', 2) as F2,

Concat(F2& ' '& F1) AS AnalystName1

Resident Test;

Can you please throw some light where i'm going wrong.

[vishsaggi]

Try this ?

Test:

LOAD AnalystFirstName & ' ' & AnalystLastName AS AnalystName;

LOAD AnalystName,

     Subfield(AnalystName, ',',2) AS AnalystFirstName,

     Subfield(AnalystName, ',',1) AS AnalystLastName;

LOAD AnalystName

FROM

QlikViewDocument.xlsx

(ooxml, embedded labels, table is RDump);

[ziadm]

You have to use preceding load in order to fix this error

at the last load these two fields are not know when you concatenate them.  Therefore, you have to use preceding load

ConCat_test:

load * ,

Concat([F2]& ' '& [F1])  AS AnalystName1;

LOAD

SubField(AnalystName, ',', 1) as [F1],

SubField(AnalystName, ',', 2) as [F2]

Resident Test;

[el_aprendiz111]

Hi,

LOAD *, SubField(Name,',',-1) & ' ' & SubField(Name,',',1) as newName;
LOAD
Name
FROM
[..\..\..\Documents\Downloads\test1.xls]
(biff, embedded labels, table is Name$);

[jagdishbr]

Thank you, Problem Resolved..

[jagdishbr]

Thanks for educating me on this. Problem Resolved

[jagdishbr]

Thank you Problem Resolved