84558_en-US

liliconcom

How to recode a column with a formula in JSL

I feel like I might be clost, I just want to use JSL to fill a blank column with the name of the file I read in.  The file does have a variable (dtPullName), but I would be happy too if I could just assign it a string:

 

dtT2 << New Column( "Quarter", Data Type(Character),Modeling Type(Nominal) );
dtT2 << select where (:Quarter);
Current Data Table() << Begin Data Update;
col = Column( 7 );
col << For Each Row( :Quarter = Match( :Quarter, "", "17_Q4", :Quarter ) );
Current Data Table() << End Data Update;

 

So far it just comes up blank

 

thank you for the help!

 

EW

Re: How to recode a column with a formula in JSL

Thank you so much!  The finishing touch on my first JSL

Re: How to recode a column with a formula in JSL

dtT2 << New Column( "Quarter", Data Type( Character ), Modeling Type( Nominal ) );
dtT2:Quarter << Set Each Value( "file name" );