Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table in my app that includes data from several data sources.
All of these data sources are connected by an ID assigned to every person.
But in order to show a persons name with their ID in a table, I would have to add in 4 different columns from 4 different sources to show the names.
I would like to see 1 column for the ID and 1 for the name, so I am wondering if it is possible to write an expression that allows for the name columns to be merged (IF statement maybe).
So if the ID does not match the 1st data source, instead of giving a blank I want it to look for the name in the next data source.
E.g. (Name[source1]IF blank=check name[source2]IF blank=check [source3] etc.....
Cheers.
May be this
If(Len(Trim(Name_Source1)) > 0, Name_Source1,
If(Len(Trim(Name_Source2)) > 0, Name_Source2,
If(Len(Trim(Name_Source3)) > 0, Name_Source3, Name_Source4)))
May be this
If(Len(Trim(Name_Source1)) > 0, Name_Source1,
If(Len(Trim(Name_Source2)) > 0, Name_Source2,
If(Len(Trim(Name_Source3)) > 0, Name_Source3, Name_Source4)))
Thank you so much!
That worked perfectly!
Appreciate the help.