By using this website, you agree to our Terms of Use (click here)
Working on a project where the data I am pulling data on a product configuration. The GI displays:
I want it to output as.
I can sort of do this with a Pivot Table but unable to concatenate the values. Now sure if there's a way to do this in GI's.
Hi there Travis, I was able to achieve this by entering the following formula into the Datafield column of the GI
=Concat([Datafield1],[Datafield2],[Datafield3])
I will say, some types of data field will return a numeric formula, but from your example, I think you should be fine.
Create a new line with the object that contains the data fields in your GI, enter the Concat formula and hopefully you should be good to go.
@dboulle thanks Dominic. I know I can do the concat to get the combined datafield. My issue is how can I take the individual lines in the first photo and make them a single line. That's my real difficulty.
@travisl Ohhhhh, could you please share a screen shot of your results table for the GI? Are your features using "attributes" or is your company using the product config module?
@dboulle Product configurator. I think I got it. I had to make a GI for each "feature" I wanted then a GI to with all those individual GI's as data sources. It's pretty slow though. Not sure there's another way without using a SQL view or some sort of SQL aggregation.
@travisl Yeah, that was going to be my next suggestion, as I am in the same predicament with the product configurator. Could you perhaps work with a pivot table?
@dboulle That was my first go to. I did the pivot table but didn't see a way to do the concatenation on the pivot table data.
Try using IIf statements
IIf( expr, truePart, falsePart )
IIf (Feature = Color), Value, 0
IIf feature = Size, Value, 0
...
@anne-r-trockman You can't do it this way that I know of. Figure 1 is how the results look in the GI. Figured 2 is how I want it to look. The results in the GI are line by line in the DAC.
I haven't worked directly with the SO GI, but we have a list of projects and use the IIF statements to get different costs in specific columns. I would assume you could do something similar....
Our Cost Price formula is =sum (IIf([PMBudget.Type]='E', [PMBudget.CuryActualAmount],0))
Our Budget formula is =sum (IIf([PMBudget.Type]='E', [PMBudget.CuryRevisedAmount],0))
I would think if you could say (in lay man terms):
Column A - SO #
Column B - if the feature =color, list the color, if not leave it blank.
Column C - if the feature = size, list size, if not leave it blank
Etc.
@anne-r-trockman Correct me if I'm wrong. The PMBudget DAC table for each ProjectID has the [PMBudget.CuryActualAmount] and [PMBudget.CuryRevisedAmount] all on the same line, correct?
Example:
