I have many tables and in each of these tables I have the same variable, but with different names and values. I give them the same name.
In list box I have 20 different value, I want to group them to 5 value for example. I recoded them in dimension, but in this case I can't use them in future.
Please help me with idea how to easy and simple to do it?
I can recode them, when I load script. But if I change name of the variable or recode, I need to reload this table again to recoded.
Maybe it's easy to use load map or somehow recode this variable, when they are already loaded.
I have moved 3 tables into one sheet. By looking at it, the data is confusing to begin with and then there are nulls. I am still not clear what the final out put you want to have. Please add an excel file mock up that shows that should be the final output.
Now your data
Basically you table is Company ID, Product and Status so if you create one table out of these three tables, it should be fine. I am still not clear on what you are calling a variable?
so this means that product name is coming differently from the source tables.... you will not be able to standerized them here unless you have an other grouping, their parent or any category that identify them....
then you can put these products in the specific buckets that you are trying to create...
