Forum Discussion
How to link two columns
Hello, i have an issue, i want to link my EEAGTNAME with my EAFCR but with one specification like
- Fill empty rows from EEAGTNAME to EAFCR
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.
2 Replies
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 ,
