Forum Discussion
Calculated column with IF...Else statement
Hmm,
this gets very theoretical without actual tables, but you can include in the CONCATENATE formular the LOOKUPVALUE, such as
"New Column" = CONCATENATE ( LOOKUPVALUE(...), ChargeID , BrandID , Fee_Type (domestic/international), Is_Premium)
not quite sure if I am loosing it here 😄
hashtag_pete
Hello mohsenask ,
could you do yet another calculated column where you concatenate the Merchant, Brand, Fee and and premium? If you do this on both sides, you could get the according fee with a lookupvalue.
Just an idea - hope it helps
hashtag_pete
Yes thats an idea I had but the the tables are coming in from Postgres except for
AllTransactions
PaymentIntentId
CompanyID
which comes from SQL Server
The Concatenation doesnt work giving an error - invalid input syntax for integer.
can you help with the correct syntax for concatenation?
