Array formula to PQ

[RaudMees]

Hello

I made a formula in Excel sheet, but now I need to convert it to PQ, but.. it will give several errors (PQ don't like @ ; and $ symbols when I paste it to PQ). Is there any option to translate it to PQ-friendly? When it's in sheet, then my table is running very slow (data is coming from CAD-software and calculating all the time makes it slow).
{=IF([@Kogus]<>"";IFERROR(INDEX($J$1:$J7;MATCH([@Alamkoost];TRIM($E$1:$E7);0))*[@Kogus];[@Kogus]);"")}

WBR
RM

 

[sandy666]

like this?
and now multiply by 6?

 

[RaudMees]

No...
W92 2090*837*140 - multiply 4
W92 2090*839*140 - multiply 6
W92 542*837*140 - multiply 3
etc..
Those names are dynamical, depends the project. That Excel file will be template and without any data inside. CAD-software will fill first sheet through export command and after reload all in PQ table I like to get filled sheets. Do You like to get a video of that?

 

[sandy666]

first answer me on this

 

[RaudMees]

Yes, there will be Moodul too.

 

[sandy666]

to be sure,
so all blank cells in column Part_type should contain word Moodul ?
your example does not contain Moodul by mistake or it should be filled via PQ ?

W92 2090*837*140 - multiply 4
W92 2090*839*140 - multiply 6
W92 542*837*140 - multiply 3

it was done in post#11
but you said multiply all by 6 because there is 6 modules, so I am

 

[RaudMees]

Now I see that post #11 is already calculated, but they don't need to multiply with 6 again.
Part_type Moodul is only for W92 and Karbik.
How did You get this result in post #11?

 

[sandy666]

Let me do all in my way and after that you'll tell me if this is what you want

 

[sandy666]

ok, see this: example

 

[RaudMees]

Hello again

I was completely busy with other development and now I am back with this table. When source data is shorter or longer, then I will have Errors. Is that something what I can just skip or it needs to be fixed?
I got some information from factory and I need to redesign whole table, I hope I can do that myself

RM

 

[sandy666]

I limited source table to 100 rows and I don't see any errors in result table(s)