Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have two tables In the data manager
I need the solution I want to add the field from another table
Example:
Table1:
X Y Z
1 AAA 123
2 BBB 456
3 CCC 789
4 DDD 101
Table2:
A B C
X Y Z
I need the output in the below format
Output:
X Y Z C
1 AAA 123 Z
2 BBB 456 Z
3 CCC 789 Z
4 DDD 101 Z
Table2 only have a single value and you want that value to be associated with all the values from Table1? Try this
Table:
LOAD X, Y, Z
FROM Table1;
Join (Table)
LOAD C
FROM Table2;
Hi Sunny,
Thanks for quick response
C is the calculated filed in the table 2 that's the reason I am getting error that filed is not found
Would you elaborate this with a better example
Hi Sunny,
I will try to explain everything step by step clearly
I have 2 Tables
Table 1 is direct one
Table 2 we have to calculate few things in the sheet
example table will be in the below format
X Y Z
1 B 03/31/2019
2 C XYZ
3 D YZA
Here I want to add the new filed quarter
with this formula 'Q' & Ceil(Month(date)/3) I have created New Filed quarter
Than I got the output
X Y Z Quarter
1 B 03/31/2019 Q1
2 C XYZ Q
3 D YZA Q
after that I want to delete all the rows what ever it is not required.
by using Where Clause I deleted the rows than I got the output
X Y Z Quarter
1 B 03/31/2019 Q1
Created field quarter I want to add in the table 1
Okay, I don't see why you can't do a join after you have calculated the value and used your where clause?
Hi Sunny
Every time quarter will change right if we do where clause after join than it will be a problem I guess
after join? I have no idea what you mean... sorry, but may be someone else can offer help here 🙂