Row wise users Splitting

[#1]

Hi All,

I have excel with folder name and user details.

The problem here is file name and the corresponding users are in one single row. But I need them to be splitted per row.

ex: Actual

Folder,user

Fol_001,sa\pr full control

              sa\pqeer-akjha Allow  FullControl

               sa\pqeeer Allow  FullControl

                   sa\pqwqwr Allow  FullControl

                   sa\prded Allow  FullControl

requirement :

Folder,user

Fol_001,sa\pr full control

  Fol_001,            sa\pqeer-akjha Allow  FullControl

Fol_001,               sa\pqeeer Allow  FullControl

    Fol_001,               sa\pqwqwr Allow  FullControl

   Fol_001,                sa\prded Allow  FullControl

Kindly assist

Thanks,

Prajna

[Anil_Babu_Samineni]

I Assume, You must have like below for inline memory

LOAD * Inline [

Folder,user

Fol_001,sa\pr full control

             , sa\pqeer-akjha Allow  FullControl

              , sa\pqeeer Allow  FullControl

               ,    sa\pqwqwr Allow  FullControl

                ,   sa\prded Allow  FullControl

];

Then use preceding load like below / Post Real and Live Data to seen

LOAD  if(Folder= '', 'Fol_001',Folder) as Folder, user Inline [

Folder,user

Fol_001,sa\pr full control

             , sa\pqeer-akjha Allow  FullControl

              , sa\pqeeer Allow  FullControl

               ,    sa\pqwqwr Allow  FullControl

                ,   sa\prded Allow  FullControl

];

OR

if(Folder= '' or isnull (Folder), Previous(Folder),Folder) as Folder

OR Look this thread by using Transformation

Fill empty cells with value from "above"

[#3]

found the solution

[#4]

Thanks, I used subfield.It worked

[MK_QSL]

Provide proper sample data.

you can achieve this by using below combination in script.

Resident Load, Peek/Previous, IsNull()

[Anil_Babu_Samineni]

Then, Share that expression and flag your response as Correct answer it demonstrates and useful to others like Us