Where not exists problem

[ziabobaz]

Hi!

I need to do the following - please, help.

FirstOrderTable:

Load

OrderN as OrderNx,

First_Purchase

Resident FlagTableTmp

Where First_Purchase=1

;

Drop Table FlagTableTmp;

Concatenate (FirstOrderTable)

Load Distinct

OrderN as OrderNx,

'0' as First_Purchase

Resident Main_table

Where not Exists(OrderNx,OrderN)

;

Rename Field OrderNx to OrderN;

The script error says: The name 'OrderN' already exists

Thank you!

[andrey_krylov · Accepted solution]

Hi, Глеб)  this is because the Main_table has not been droped and field OrderN exists in the app. QV doesn't support renaming fields in the only table.

[ziabobaz]

Andrey, meaning, the Rename works with entire app, rather than particular table? Okay, I can handle it.

How about the rest of the script? Something is wrong:

[andrey_krylov]

Can you share a sample app? I can't fully understand the issue.

[ziabobaz]

OMG, I just noticed my Flag was selected in a front end.

Sorry, the scipt works fine.