Forum Discussion
How to link two columns
Hi Jeffreyjar
Please always show your sample data in text-tabular format in addition to (or instead of) the screen captures. A screen cap doesn't allow people to readily copy the data and run a quick test and thus decreases the likelihood of your question being answered.
Try the following:
1. Create a custom column "NewCol" with the code
= if [EAFCR] = null or [EAFCR] = "" then [EEAGTNAME] else [EAFCR]2. Delete the EAFR column
3. Rename "NewCol" as "EAFR"
If this does not work please share a sample of the data as specified above and the expected result
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Hi Jeffreyjar
Please always show your sample data in text-tabular format in addition to (or instead of) the screen captures. A screen cap doesn't allow people to readily copy the data and run a quick test and thus decreases the likelihood of your question being answered.
Try the following:
1. Create a custom column "NewCol" with the code
= if [EAFCR] = null or [EAFCR] = "" then [EEAGTNAME] else [EAFCR] 2. Delete the EAFR column
3. Rename "NewCol" as "EAFR"
If this does not work please share a sample of the data as specified above and the expected result
|
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Thanks for for the help ,