Replies:

Thanks Peter for your help %OR will help

Expression="%OR({[Demographics].[H10].[Citizenship].&[USA],[Demographics].[H10].[Citizenship].&[U.S.A],[Demographics].[H10].[Citizenship].&[US]})"   

Can you advice how to use the same expression to say if citizenship value is not one of these values something like this NOT %OR?

Hi @Dmitry Maslennikov 
This suggestion worked thanks, one I am looping over 60 columns and all is working fine. One thing is breaking sometimes data is single codes ' in the text and such records are not being saved. Any suggestion how to handle this?

For i=1:1:60 {
set FieldName = FieldName_",Field"_i
set FieldVaue = FieldVaue_"','"_$Piece(pInput,"|",i)}

Best Practices to Common Problems: This will be quick start to implement real time example not generic documentation which is hard to follow and real things are not visible

Followers:
Ahmad has no followers yet.
Following:
Ahmad has not followed anybody yet.
Global Masters badges: