How to remove particular column from dataset which are present in list

Question

I am having a list of book present in excel like below format

Bookid

Flax123

Flax461

Strt310

From the input data i am reading the file which the columns present in that list like  below

Ab12-34  Flax123-xyz Strt310-abc  Lmn123

122.          123345.         122344.        Oepejd

123455.    Jdjldldp.        Wejrjdjb.       Jdjdjdk

Whatever the column names that are contains in  dataset from that list should be removed or delete in the output

prthmesh111 · Answer

HI QUI,

It works fine but if you look at column name (-) is getting replace with ( _ )  is there any way to keep the same column name as it

Qiu · Answer

@prthmesh111 
Hope this will work

New Workflow1A.yxmd

mceleavey · Answer

Hi @prthmesh111 ,

A little bit of transpose and crosstab magic should to the trick:

solution.yxmd