Level 2 Data Hub Historic Volume Importing Data Error

Hagar · July 2023

I need some help with these columns mapping can anyone guide me is this correct or not cause it's giving me An error ?? screenshots attached.

Screenshot_27.png

Uploaded Jul 5, 202334.39 KB

Screenshot_28.png

Uploaded Jul 5, 202360.91 KB

Screenshot_29.png

Uploaded Jul 5, 202371.24 KB

Screenshot_30.png

Uploaded Jul 5, 202343.08 KB

Screenshot_31.png

Uploaded Jul 5, 202334.49 KB

Deepak5805 · July 2023

Hi Hagar,

Hope you are doing good.

So I will suggest you to go through the options for mapping in Volumes part. It is saying that Invalid Line Item Identifier. So Click on the Volumes and go the options available. You will find a way.

And have a look on your time scale mapping. If you have further issues drop a message. I will happy to help you.

Thanks

Deepak

Hagar · July 2023

Hello @Deepak5805

Thanks for helping me actually i am trying with the volumes line item many times still giving me the error it's not mapping but regarding the time i am using specific year 2019, and the parameter W.

Deepak5805 · July 2023

Hi @Hagar ,

There is other option called "Fixed Line Item". Please have a go through on this. And revert your time mapping to original.

Hope it will solve your issue.

Thanks

Deepak

Bishalpilley · July 2023

@Hagar

Check Format of the time mapping.

Screenshot 2023-07-05 11.00.38 AM.png

Thanks,

Bishal

Hagar · July 2023

Hello @Bishalpilley

I am mapping data for Historical volumes is it required to edit calendar to quarter ?? as it's Week Time Scale ??

Deepak5805 · July 2023

Hi @Hagar ,

No its not needed. Only in Import you have to check your mapping is correct or not.

I will suggest you to do a Trail and Error method so that you can get some clarity on that concept.

Thanks

Deepak

Hagar · July 2023

Hi @Deepak5805

i have made the steps you told me and i still have tis

Screenshot_40.png

Hagar · July 2023

Thanks @Deepak5805

Actually i've been trying long time but i am gonna try again maybe i can solve it thanks for your efforts much appreciated i gonna update if i could make it