Replace Values in INPUTFIELD Through Partial Reload

[mbespartochnyy]

Hello everyone,

I'm facing a challenge replacing values in a table. The task is simple:

• During full reload table loads with null values in fields Input_Value 1 through 5
• Then, in real life, users get data in a separate spreadsheet that is then transformed to look like Manual_Input table (see attached QVW)
• Once transformation is complete and the table with data to be loaded looks like the original data, partial reload is executed to replace null values with whatever values have been entered (See Populated tab in attached spreadsheet)
• A partial reload is executed and, ideally, Manual_Input table would have the values replaced with whatever user populated in the spreadsheet.

I wrote a script to load null values and a partial reload script to replace values, but when I execute a partial reload, fields Input_Value1 to 5 are populated with 0 through 75 instead of actual values that user has entered. Has anyone faced this before or knows how to solve this?

Thanks,

Mikhail Bespartochnyy

[sunny_talwar]

How about you try this:

IF IsPartialReload() THEN

DROP Table Manual_Input;

Manual_Input:

Add LOAD Field_Name,

    Input_Value,

    Input_Value2,

    Input_Value3,

    Input_Value4,

    Input_Value5

FROM

[Replace Load.xlsx]

(ooxml, embedded labels, table is Populated);

ENDIF;

[sunny_talwar]

That did not work....

[mbespartochnyy]

That works but it now input functionality is disabled. I tried adding INPUTFIELD in partial reload script like this:

IF IsPartialReload() THEN

DROP Table Manual_Input;

INPUTFIELD Input_Value;

INPUTFIELD Input_Value2;

INPUTFIELD Input_Value3;

INPUTFIELD Input_Value4;

INPUTFIELD Input_Value5;

Manual_Input:

Add LOAD Field_Name,

    Input_Value,

    Input_Value2,

    Input_Value3,

    Input_Value4,

    Input_Value5

FROM

[Source-Data\CorporateCard\Replace Load.xlsx]

(ooxml, embedded labels, table is Populated);

ENDIF;

But that didn't do it either. It went back to populating 0-75 numbers.

[sunny_talwar]

Ya I saw that.... let me try something else....

[sunny_talwar]

This works

IF IsPartialReload() THEN

DROP Table Manual_Input;

Manual_Input:

Add LOAD Field_Name,

    Input_Value,

    Input_Value2,

    Input_Value3,

    Input_Value4,

    Input_Value5

FROM

[Replace Load.xlsx]

(ooxml, embedded labels, table is Populated);

DROP Table Manual_Input;

INPUTFIELD Input_Value;

INPUTFIELD Input_Value2;

INPUTFIELD Input_Value3;

INPUTFIELD Input_Value4;

INPUTFIELD Input_Value5;

Manual_Input:

Add LOAD Field_Name,

    Input_Value,

    Input_Value2,

    Input_Value3,

    Input_Value4,

    Input_Value5

FROM

[Replace Load.xlsx]

(ooxml, embedded labels, table is Populated);

ENDIF;

[mbespartochnyy]

That makes no sense to me but it worked...partially. I did a full reload then a partial reload with that script and  it didn't work for me at first (populated 0-75 again). Then I commented out second portion of the partial reload script, this one:

DROP Table Manual_Input;

INPUTFIELD Input_Value;

INPUTFIELD Input_Value2;

INPUTFIELD Input_Value3;

INPUTFIELD Input_Value4;

INPUTFIELD Input_Value5;

Manual_Input:

Add LOAD Field_Name,

    Input_Value,

    Input_Value2,

    Input_Value3,

    Input_Value4,

    Input_Value5

FROM

[Replace Load.xlsx]

(ooxml, embedded labels, table is Populated);

and did a partial reload. It populated values and removed the input functionality. Then I uncommented the second portion, did a full reload, and then partial reload and it populated the table with correct values and the input functionality was working. Both full and partial reloads after that worked as expected until I change the values in the excel spreadsheet. For example, changing any of the location names in the spreadsheet and then doing full and partial reload still loads the original location names.

Mikhail

[sunny_talwar]

I am confused.... can you repeat... I wish I could have just walked over to your desk

[mbespartochnyy]

haha I can't describe how much I miss those days. Basically, if you change a location name or any of the values in the spreadsheet, then do a partial reload, the new values are not pulling in.

[sunny_talwar]

Checking now...