mceleavey - MACRO
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Mceleavey,
I've been using your multiple schema macro to bring in monthly files and combine them together but i came across a challenge it would be great if you could help.
after combining all the files Say i have a formula field called (TEST) where I'm putting in my business logic and I'm referencing a Column called XYZ inside my formula field.
but the column XYZ was same across two months but in Feb it was called ABC in this case how can i reference the column ABC within my formula field?
Feb | ABC |
March | XYZ |
April | XYZ |
- Labels:
- Macros
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Taging @mceleavey so that he gets a notification on this post 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @suby ,
and thank you @atcodedog05 .
Can you let us know what you're trying to achieve here? What is the formula? What is the desired outcome?
Thanks,
M.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
its pretty straight forward i mean ..
The output would be to show the all the historic values for my (TEST) column in my Tableau Dashboard.
The TEST is formula field in Alteryx inside the TEST column i have an IF condition and in that IF condition I'm referencing the XYZ column the results where okay for the month of March and April but for the month of FEB the column was called ABC I'm getting no results so in this case how can i handle this.
Feb | ABC |
March | XYZ |
April | XYZ |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Apologize for the confusion..
My Data set looks like this
In this scenario the Values remains same across for all the three months the only difference is the Column name is referenced as ABC in the month of FEB.
But if you look at my calculation I'm referencing the XYZ column but later then i found that the column name was different in my Feb Month Data set which is called as ABC.
So when i produce a report on my Dashboard I'm getting values for March and April and this is fine since my formula field is referencing XYZ but here I'm missing my Feb values.
Not finding any fault on your macro its an amazing macro but i wanted to know how to handle this scenario because i have lots of joins and union downstream on my workflow.