Multi-Select in Column and Excel Dropdown for Improved Data Import Experience

[chavda-bhavik]

Introduce the ability for users to perform multi-select in a column within Impler.io's data import feature. This enhancement includes adding support for selecting multiple items from a dropdown in the created Excel sample.
Additionally, during the widget review phase, an error should be triggered if the selected items are not from the provided list. This feature aims to open doors for a wide range of data import needs where the user wants to import data like tags, categories etc.

Use Case Scenario:

• Consider a scenario where a user is importing a dataset containing information about products.
• The dataset includes a column for product categories. With the multi-select feature, the user can now choose multiple categories for each product directly in the Excel dropdown.
• This is particularly beneficial when dealing with products that belong to multiple categories simultaneously.

Expected Behavior:

1. Users can select multiple items from a dropdown in the Excel sample for a specific column.
2. During the widget review phase, an error is triggered if any selected item in the multi-select column is not part of the predefined list.

Additional Context:

Priority:
Medium

Acceptance Criteria:

1. Users can select multiple items from a dropdown in the Excel import interface.
2. The widget review phase triggers an error if any selected item is not from the predefined list.
3. The feature is successfully integrated and does not affect the existing import process.