List

[Anonymous]

Hi ,

Please find the attached document and please provide me the suggestions.

[adamdavi3s]

Here is a little something you can add in the script to do this if you want to load the data in:

preceedingload:
load EId,Ename,if(EId='ABCE005' AND Ename = '-', 'Logistics',Dept) as Dept;

LOAD * INLINE [
    EId, Ename, Dept
    E001, James,IT
    E002, Tom,Sales
    E003, Jim,ENGG
    E004, Henry,MARKT
    ABCE005, -
    ABCE006, -
];

If you end up with loads of blanks to fill in then you could use a mapping table or a pick match to make it much more efficient

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

[Anonymous]

Thanks Adam for response

Could you please explain me how to do at front end

[Anonymous]

Any suggestions pls

[adamdavi3s]

You should be able to do exactly the same, just put the if formula in the list box as an expression.

I've attached a file which includes this for you

[adamdavi3s · Accepted solution]

any help?

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

[MindaugasBacius]

Try like this:

LOAD EId
  ,Ename
  ,if(EId = 'ABCE005' and Ename = '-', 'Logistics', Dept) as Dept
INLINE [
    EId, Ename, Dept
    E001, James,IT
    E002, Tom,Sales
    E003, Jim,ENGG
    E004, Henry,MARKT
    ABCE005, -
    ABCE006, -
];

Result:

See the attachment.