How to extract variables from predictive tool (Linear) by Group

[Benjanez]

Hello!

I am trying to find a way to extract the variable out of the predictive tool such as the coefficient based on a group. I will need them after on my work flow.

Attached the example data on the workflow

Desired output

Group	Variable	Estimate	Std_Error	t_value	P_value
Product A	(Intercept)	-0.70555	8.33E-03	-84.7021	3.76E-64
Product A	y	-1.68775	0.101122	-16.6903	3.21E-24
Product B	(Intercept)	-1.00938	7.55E-03	-133.607	5.79E-76
Product B	y	-2.33472	0.10138	-23.0293	1.76E-31

Thank you in advance,

Best regards,

[pedrodrfaria]

Hi @Benjanez 

You are able to output the data reports from the R output on the Linear Regression Model.

So you can create a logic to output to an excel file and load this excel file afterwards.

[Benjanez]

Hello @pedrodrfaria 

Thank you for your feedback, it is true we can we out the coefficient, however, it a output aggregated not for the product A and B, not one result for product A and for product B, at the end we should get the results split it into the different products