Forum Discussion
Display result base on condition
Hello yangc10
Please tell me if the below solution would solve your problem.
Step 1
- Add a column in Pikachu#TG05 table to denote the sheet name.
- Except the sheet name column unpivot all the other columns, So that you have grade and price as two columns.
- Create a Primary key by concatenating table name and grades. The final table should look like below.
Step 2
- Create a Primary key in main table by concatenating description and graded column similar to above.
Now you have a unique identifier to create a relationship and make the calculation. The best part is you can make all the other tables similar to Pikachu#TG05 and append all of them together. So that you will only have 1 table with cards and price information and the main table.
Let me know if this helps or have any questions.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
would it be possible to do something like
IF Main["Description"] is equal to Pikachu[Name] then Main["Market Price"] = Pikachu[(Main["Graded"])
reason for Pikachu[(Main["Graded"]) is b/c we're trying to get the graded value from Main to grab the column names from Pikachu table.
Yes it is possible as you ask for, But that's gonna be a tedious work to type the formula. But still you would need PK to do this.